use ATE
go



IF OBJECT_ID ( 'TTestItem_select_SNDT', 'P' ) IS NOT NULL 
    DROP PROCEDURE TTestItem_select_SNDT;
GO
CREATE PROCEDURE TTestItem_select_SNDT
	@ProductSN nvarchar(50),  
	@RecordTime datetime 
AS    
    SET NOCOUNT ON;
    select ProductSN,RecordTime,TestItemName,TestTypeName,TestTypeID,StartF,StopF,Max,Min,HighSpec,LowSpec,IsPass
	from TTestItem
	where ProductSN=@ProductSN and RecordTime=@RecordTime	
	order by TestItemName
GO




